﻿CREATE PROCEDURE [dbo].[SupplierReturnLinesSelect]
AS
	SET NOCOUNT ON;

SELECT L.Id,  L.DocId, L.PartyId, 
L.Qntty * (-1) AS Qntty, L.RetailSum * (-1.0) AS RetailSum, L.ReturnLineId,
L.Note, L.MD, L.MW 
FROM CA.GoodsDocLines AS L WITH (NOLOCK)
INNER JOIN CA.Documents AS D WITH (NOLOCK) 
ON L.DocId = D.Id AND D.DocTypeId = 8



